
Select * from PS_CPR_TEMP0007 --Horario por dias y calendario

INSERT INTO PS_CPR_TEMP0007 ( PROCESS_INSTANCE 
 , EMPLID 
 , EMPL_RCD 
 , BUSINESS_UNIT 
 , START_DT 
 , DAYOFWK_MON 
 , FLAG 
 , CPR_FST_ASG_FLD 
 , STRT_STOP_DIFF 
 , START_TIME 
 , END_TIME 
 , KZN_CR_IDNM ) 
 SELECT A.PROCESS_INSTANCE 
 , B.EMPLID 
 , B.EMPL_RCD 
 , B.BUSINESS_UNIT 
 , A.START_DT 
 , A.DAYOFWK_MON 
 , B.FLAG 
 , B.CPR_FST_ASG_FLD 
 , B.STRT_STOP_DIFF 
 , B.START_TIME 
 , B.END_TIME 
 , B.KZN_CR_IDNM 
  FROM PS_CPR_TEMP0005 A 
  , PS_CPR_TEMP0003 B 
 WHERE A.DAYOFWK_MON = B.DAYOFWK_MON 
   AND A.PROCESS_INSTANCE = B.PROCESS_INSTANCE 
   AND A.PROCESS_INSTANCE = %ProcessInstance 
  ORDER BY B.EMPLID, B.EMPL_RCD, A.START_DT, B.START_TIME